forum

home / developersection / forums / how to refresh gridview after every insert command automatically?

Ask Question

How to refresh gridview after every insert command automatically?

Anonymous User 2270 28-Aug-2014

I am inserting data to database when i click submit button data inserted into Database but no changes get reflected in GridView without refreshing the page.

c#
Updated on 28-Aug-2014
Anonymous User

Other

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Sumit Kesarwani

Sumit Kesarwani

28-Aug-2014
Hi Pravesh, 

public void GetData()        
    {
        try
        {
           
SqlConnection connection = new SqlConnection();
           
connection.ConnectionString = ConfigurationManager.ConnectionStrings["mysql"].ConnectionString;
            String sql= "Your Query";
            DataSet ds= new DataSet();
           
SqlDataAdapter da = new SqlDataAdapter(sql, connection);
           
da.Fill(ds);
            DataTable dt = new DataTable();
            dt =ds.Tables[0];
           
GridView1.DataSource = dt;
        }
        catch (SqlException ex)
        {
        }
        catch (Exception e)
        {
        }
    }
advertising
advertising

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy